This table is available to be imported or exported as part of the system initialization process. Use this process to quickly build the tables in your system. The following fields are defined in this table. If a field is REQUIRED, it must be supplied as part of the import process.
Select Phase 2 - Broker when importing/exporting broker type information.
Screen Label | Type | Alias Field | Req | Default | Possible Values | Table Alias |
Broker | C 6 | BrokerId | Yes | |||
Old Id | C 15 | Old_Id | ||||
Broker Name | C 30 | Name | Yes | |||
Contact | C 30 | Contact | ||||
Address1 | C 30 | Address1 | ||||
Address2 | C 30 | Address2 | ||||
City | C 20 | City | ||||
State | C 2 | State | ||||
Zip | C 10 | Zip | ||||
Phone1 | C 14 | Phone1 | ||||
Phone2 | C 14 | Phone2 | ||||
Fax | C 14 | Fax | ||||
Commission (Y/N) | C 1 | Commission | N | Y,N | ||
Commission Expense Account | C 4 | Account | Account | |||
Commission Expense Cost Center | C 6 | CostCenter | Cost Center | |||
Commission only on Collected Sales | C 1 | Collected | Y | Y,N | ||
Exclude Accruals for Commissions ? | C 1 | Accruals | N | S,N,B,X |
Security Required : Tables - Brokers
See Also | Used In |